Communication Details Wizard

This report imports all active patients communication details and a Pivot Table counts up all the mobiles to show patients with more than 1 mobile number.

It can also be used to show emails and all different forms of numbers stored in wrong categories or wrong number formats.

This was created to help tidy up mobiles in a practice as Vision+ only uses the first mobile number if a patient has more than one recorded.

Download

Updates

  • Updated to v1.3b 9NdP%, 9NdQ% child levels are now shown separately
  • Updated to v1.3a Separates the Title, Surname and Forename into individual columns and includes hierarchy for 9NdP% and 9NdQ%
  • Updated to v1.3 Now includes Age, DOB, Sex and Consent/Declined SMS or Email
    • Declined SMS or Email shown in red text
    • It also includes a validation check against Types that contain the word "phone" or "Email" in the text
    • The mobile validation strips out all non-numeric characters and the number must be 11 characters in length
    • The email validation just looks for an @ symbol in the text
    • Any red text means it has failed the validation check
  • Updated to V1.2 (30/10/2017) Now includes a column to show contact numbers that include alphabetic text characters
Note – To print this topic select Print in the top right corner and follow the on-screen prompts.